Customer

Entity Definition

Logical Name : Customer
Physical Name : PA_CT

A PartyRoleAssignment type that represents the association between a retailer on one hand and an individual or organization (Party) on the other hand where the party is a Consumer that has completed at least one purchase and whose associated ConsumerConversionState indicates their status as a CUSTOMER. We are using the term "Consumerr" to reflect the idea that this PartyRoleAssignment represents parties that retailers are SELLING TO (or trying to sell to). In other entities we differentiate between parties that are in a pre-sale state (typically they're in the customer acquisition funnel), an active state (they have purchased items and are ActiveCustomers) , an inactive state (InactiveCustomers) or a "dead" state (ExCustomers).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerID (PK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_CT Identity integer
ConsumerrConversionStateID (FK) Token ID for a PartyConversionState instance. ID_CT_CVN_ST Identity integer ConsumerConversionState(CO_CT_CVN_ST)
PartyID (FK) A unique, system assigned identity for a Party. ID_PRTY Identity integer Party(PA_PRTY)
AnonymousFlag A boolean indicator that tells if this is an anonymous customer or not. If TRUE this is an anonymous customer that has no KeyCustomer (and related dependent information) and no PartyContactMethod information associated with it. FL_ANNYMS Flag integer

Relationships

Parent Entity Verb Phrase Child Entity
ConsumerConversionState defines condition for Customer
Party may be Customer
Customer donates Contribution
Customer provides CustomerSurveyResponse
Customer follows CustomerDemographicRole
Customer places CustomerOrder
Customer has used RetailStoreCustomer
Customer may be a KeyCustomer
Customer wrote CustomerCorrespondence
Customer posesses CustomerAssetAssociation
Customer is a party to RetailTransaction
Customer celebrates CustomerOccasion

Logical Views containing Customer

Logical View
Logical 02200 - Transaction Macro View
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View
Logical 02309 - Retail Transaction Delivery
Logical 02315 - Retail Transaction - Customer Order
Logical 02340 - Retail Transaction - Shipping View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 05050 - Taxation - Registration and Certification View
Logical 05100 - Taxation - Rules View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07015 - Customer Lifecycle and Registration
Logical 07017 - Consumer-Customer Lifecycle Context View
Logical 07019 - Party-Consumer-Customer Household View
Logical 07020 - Enterprise Anonymous Customer
Logical 07030 - Customer Segment Independent Characteristics
Logical 07040 - Customer Segment Dependent Behavior
Logical 07600 - Customer Order - Macro View
Logical 07610 - Customer Order - Maintenance View
Logical 07620 - Customer Order - Inventory Control View
Logical 10400 - Enterprise - Channels